﻿<?xml version="1.0" encoding="utf-8" ?>
<Database Name="MvcEngine" xmlns="http://schemas.microsoft.com/linqtosql/mapping/2007">
	<Table Name="dbo.Gallery" Member="MvcEngine.Gallery.Models.GalleryData">
		<Type Name="MvcEngine.Gallery.Models.GalleryData">

			<Column Name="Id" Member="Id" IsPrimaryKey="true" DbType="uniqueidentifier" IsDbGenerated="false" CanBeNull="false"/>
			<Column Name="Name" Member="Name" DbType="NVarChar(256)" CanBeNull="false"/>
			
			<Column Name="PageId" Member="PageId" DbType="uniqueidentifier" CanBeNull="false"/>
			<Column Name="Fields" Member="Xml" DbType="NVarChar(Max)" CanBeNull="true"/>
			<Column Name="CreatedDate" Member="CreatedDate" DbType="DateTime" CanBeNull="false"/>
			<Column Name="ModifiedDate" Member="ModifiedDate" DbType="DateTime" CanBeNull="false"/>
			<Column Name="CreatedBy" Member="CreatedBy" DbType="uniqueidentifier" CanBeNull="true"/>
			<Column Name="ModifiedBy" Member="ModifiedBy" DbType="uniqueidentifier" CanBeNull="true"/>
		</Type>
	</Table>

	<Table Name="dbo.[Gallery.Category]" Member="MvcEngine.Gallery.Models.GalleryCategory">
		<Type Name="MvcEngine.Gallery.Models.GalleryCategory">

			<Column Name="Id" Member="Id" IsPrimaryKey="true" DbType="uniqueidentifier" IsDbGenerated="false" CanBeNull="false"/>
			<Column Name="GalleryId" Member="GalleryId" DbType="uniqueidentifier" CanBeNull="false"/>
			<Column Name="Name" Member="Name" DbType="NVarChar(256)" CanBeNull="false"/>
			<Column Name="Slug" Member="Slug" DbType="NVarChar(256)" CanBeNull="false"/>
			<Column Name="Description" Member="Description" DbType="NVarChar(MAX)" CanBeNull="true"/>
			<Column Name="Keywords" Member="Keywords" DbType="NVarChar(MAX)" CanBeNull="true"/>

			<Column Name="OrderNumber" Member="OrderNumber" DbType="int" CanBeNull="false"/>
			<Column Name="Visible" Member="Visible" DbType="bit" CanBeNull="false"/>

			<Column Name="CreatedDate" Member="CreatedDate" DbType="DateTime" CanBeNull="false"/>
			<Column Name="ModifiedDate" Member="ModifiedDate" DbType="DateTime" CanBeNull="false"/>
			<Column Name="CreatedBy" Member="CreatedBy" DbType="uniqueidentifier" CanBeNull="true"/>
			<Column Name="ModifiedBy" Member="ModifiedBy" DbType="uniqueidentifier" CanBeNull="true"/>
		</Type>
	</Table>

	<Table Name="dbo.[Gallery.Images]" Member="MvcEngine.Gallery.Models.GalleryImage">
		<Type Name="MvcEngine.Gallery.Models.GalleryImage">

			<Column Name="Id" Member="Id" IsPrimaryKey="true" DbType="uniqueidentifier" IsDbGenerated="false" CanBeNull="false"/>
			<Column Name="Name" Member="Name" DbType="NVarChar(256)" CanBeNull="false"/>
			<Column Name="Url" Member="Url" DbType="NVarChar(256)" CanBeNull="false"/>
      <Column Name="Type" Member="Type" DbType="NVarChar(50)" CanBeNull="false"/>
			<Column Name="Description" Member="Description" DbType="NVarChar(MAX)" CanBeNull="true"/>
			<Column Name="Visible" Member="Visible" DbType="bit" CanBeNull="false"/>
			<Column Name="CreatedDate" Member="CreatedDate" DbType="DateTime" CanBeNull="false"/>
			<Column Name="ModifiedDate" Member="ModifiedDate" DbType="DateTime" CanBeNull="false"/>
			<Column Name="CreatedBy" Member="CreatedBy" DbType="uniqueidentifier" CanBeNull="true"/>
			<Column Name="ModifiedBy" Member="ModifiedBy" DbType="uniqueidentifier" CanBeNull="true"/>
		</Type>
	</Table>

	<Table Name="dbo.[Gallery.ImageCategories]" Member="MvcEngine.Gallery.Models.GalleryImageCategory">
		<Type Name="MvcEngine.Gallery.Models.GalleryImageCategory">

			<Column Name="Id" Member="Id" IsPrimaryKey="true" DbType="uniqueidentifier" IsDbGenerated="false" CanBeNull="false"/>
			<Column Name="CategoryId" Member="CategoryId" DbType="uniqueidentifier" CanBeNull="false"/>
			<Column Name="ImageId" Member="ImageId" DbType="uniqueidentifier" CanBeNull="false"/>
			<Column Name="OrderNumber" Member="OrderNumber" DbType="int" CanBeNull="false"/>
			<Column Name="CreatedDate" Member="CreatedDate" DbType="DateTime" CanBeNull="false"/>
			<Column Name="ModifiedDate" Member="ModifiedDate" DbType="DateTime" CanBeNull="false"/>
			<Column Name="CreatedBy" Member="CreatedBy" DbType="uniqueidentifier" CanBeNull="true"/>
			<Column Name="ModifiedBy" Member="ModifiedBy" DbType="uniqueidentifier" CanBeNull="true"/>
		</Type>
	</Table>



</Database>